﻿

CREATE proc [Projects].[GetBusinessCaseStatusList]
@Status	int = null
as
begin
	set nocount on
	
	select	ps.ProjectStatus,
			ps.StateText,
			ps.FilePath
	from	Projects.domProjectStatus ps
	where	ps.[ProjectStatus] = @Status
				or @Status is null
	order by ps.ProjectStatus

end
GO


